[dbo].[BAECartEventDelete]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAECartEventDelete

Property	Value
ANSI Nulls On
Quoted Identifier On

Name	Data Type	Max Length (Bytes)
@CartEventID	int	4

CREATE procedure [dbo].[BAECartEventDelete] @CartEventID as
int
AS
    DECLARE @registrantId as varchar(16), @eventCode as varchar(16);

    SELECT @registrantId = CartEvent.RegistrantID, @eventCode = CartEvent.EventCode
    FROM CartEvent
    WHERE CartEvent.CartEventID = @CartEventID;

    DELETE
    FROM CartEvent
    WHERE CartEventID = @CartEventID;

    EXEC BAEEventDeleteRegistrant @registrantId, @eventCode;

GO